Data Visualization Case (Laetitia H.)¶
If I were to answer the case with one graph...¶
here is how the recruitment process looks like
The different possible application stages are ... (alphabetical order)¶
- Use case : as a recruiter, I want to select "Recruiter ap..." for an entry, which one should I select?
- Use case 2 : as a recruiter, I just received an application, and I screened it, what stage should I update? Application Review? Recruiter Screening? Screened? Application Stage, even?
We could take a bold hypothesis and amend the stage names :
- Recruiter application (spelling correct)
- Interviews (1,2,3) can be either F2F or Phone/Video -> group
- Test SHL is also take home
- Recruiter application is also Application stage
- Application Review = Hiring Manager Review
In CONCLUSION, the stage name is the key issue as it seems to provide confusion. Yet, the process does also loop over and over. We could analyze deeper to provide a more complete answer.
High level summary of the recruitment per status : rejected - active - hired¶
Agenda - Elements from the highlight summary to study :
- Number of applications by candidate
- Stages analysis per application
- Special case : 10 stages for this candidate
- Length of application - length of stages
- Department busy-ness evolution
1. Number of applications by candidate¶
2. Stages analysis per application¶
3. Special case : 10 stages for this candidate (extreme case)¶
1 candidate went through 10 stages of candidacy to be hired after 65 days since first entry log. That was his second application.
| candidate_id | job_id | applied_at | length_per_application | entry_log_wait | sum_applications_per_candidate | |
|---|---|---|---|---|---|---|
| 69 | 0x58E38E6EE17BF0549F3B3E2C1D20FEBC | 1249559 | 2020-01-15 00:26:00 | 65.0 | 65 | 2 |
4. Number of application - length of stages¶
5. Department busy-ness evolution¶
In full conclusion ... Is it the process that could be improved? Or the systems to handle business evolution that needed to be scaled up?